RESULT CACHE
Short Description
The RESULT CACHE is being accessed.
Detailed Description​
A result cache stores the results of database queries or query blocks. This cache can be located in the SGA, or in client side memory. Rows cached are available across sessions and even across statements until they go stale.
Further Reading​
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
- Oracle Tuning Guide - Tuning the RESULT CACHE
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.